Excel 2016 for Advertising Statistics by Thomas J. Quirk & Eric Rhiney

Author:Thomas J. Quirk & Eric Rhiney
Language: eng
Format: epub
Publisher: Springer International Publishing, Cham

D19: the result of the formula needed to compute cell B19 (use two decimals)

D22: =SQRT(D19) (no spaces between symbols) (use two decimals)

This formula should give you a standard error (s.e.) of 1.98.D25: 1.96

(Since df = n1 + n2 – 2, this gives df = 109 – 2 = 107, and the critical t is, therefore, 1.96 in Appendix E.)

D28: =(D4 – D5)/D22 (no spaces between symbols) (use two decimals)

This formula should give you a value for the t-test of: −4.55.

Nest, check to see if you have rounded off all figures in D13: D28 to two decimal places (see Fig. 5.11).

Fig. 5.11Results of the t-test Formula for the Soft Drink Taste Test

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.